██    ██ ██    ██  ██████  ██  ██████  ██    ██ ███████ ██████  ██    ██ 
     ██  ██  ██    ██ ██       ██ ██    ██ ██    ██ ██      ██   ██  ██  ██  
      ████   ██    ██ ██   ███ ██ ██    ██ ██    ██ █████   ██████    ████   
       ██    ██    ██ ██    ██ ██ ██ ▄▄ ██ ██    ██ ██      ██   ██    ██    
       ██     ██████   ██████  ██  ██████   ██████  ███████ ██   ██    ██    
                                      ▀▀
Cards - Execution started 24/12/2023 20:07 UTC
By Guilherme Ruiz

Table of Contents ¶

  • 1  Data aquisition
    • 1.1  Fetch online data
    • 1.2  Merge data
  • 2  Check changes
    • 2.1  Load previous data
    • 2.2  Generate changelog
    • 2.3  Save data
  • 3  Data visualization
    • 3.1  Full data
    • 3.2  Card types
    • 3.3  Monsters
      • 3.3.1  Attributes
      • 3.3.2  Primary types
        • 3.3.2.1  Has effect discrimination
        • 3.3.2.2  Is pendulum discrimination
        • 3.3.2.3  By attribute
      • 3.3.3  Secondary types
        • 3.3.3.1  By attribute
        • 3.3.3.2  By secondary type
      • 3.3.4  Monster types
        • 3.3.4.1  By Attribute
        • 3.3.4.2  By primary type
        • 3.3.4.3  By secondary type
      • 3.3.5  ATK
      • 3.3.6  DEF
      • 3.3.7  Level/Rank
        • 3.3.7.1  ATK statistics
        • 3.3.7.2  DEF statistics
      • 3.3.8  Pendulum scale
        • 3.3.8.1  ATK statistics
        • 3.3.8.2  DEF statistics
        • 3.3.8.3  Level/Rank statistics
      • 3.3.9  Link
        • 3.3.9.1  ATK statistics
      • 3.3.10  Link Arrows
        • 3.3.10.1  By combination
        • 3.3.10.2  By unique
        • 3.3.10.3  By link
    • 3.4  Spell & Trap
      • 3.4.1  Properties
    • 3.5  Effect type
      • 3.5.1  Card type discrimination
    • 3.6  Archseries
      • 3.6.1  By card type
      • 3.6.2  By primary type
      • 3.6.3  By secondary type
      • 3.6.4  By monster type
      • 3.6.5  By property
    • 3.7  Artworks
      • 3.7.1  By card type
      • 3.7.2  By primary type
    • 3.8  Errata
      • 3.8.1  By card type
      • 3.8.2  By primary type
      • 3.8.3  By artwork
    • 3.9  TCG & OCG status
      • 3.9.1  TGC status
        • 3.9.1.1  By card type
        • 3.9.1.2  By monster type
        • 3.9.1.3  By archseries
      • 3.9.2  OCG status
        • 3.9.2.1  By card type
        • 3.9.2.2  By monster type
        • 3.9.2.3  By archseries
      • 3.9.3  TCG vs. OCG status
  • 4  Extras
    • 4.1 Multiple secondary types
    • 4.2 Not yet released
    • 4.3 Counters and Tokens
  • 5  Epilogue
    • 5.1  HTML export

Data aquisition¶

Fetch online data¶

Downloading monsters

  0%|          | 0/8 [00:00<?, ?attribute/s]
Output()
Output()
Output()
Output()
Output()
Output()
Output()
Output()
8308 results


Downloading SpellsThe history saving thread hit an unexpected error (OperationalError('attempt to write a readonly database')).History will not be written to the database.


Output()
2515 results

Downloading Traps

Output()
1888 results


Downloading tokens

Output()
210 results

Downloading counters

Output()
15 results

Downloading all errata

  0%|          | 0/3 [00:00<?, ?initial/s]
Output()
Output()
Output()
5039 results

Merge data¶

Data merged

Check changes¶

Load previous data¶

No cards files

Generate changelog¶

Skipped

Save data¶

Data saved

Data visualization¶

Full data¶

Name Password Card type Property Archseries Effect type TCG status OCG status Page name Page URL Artwork Modification date Errata Attribute Primary type Secondary type Monster type DEF Pendulum Scale Link Link Arrows ATK Level/Rank
Loading... (need help?)

Full data available to download here

Card types¶

Total number of card types: 3
No description has been provided for this image

Monsters¶

Attributes¶

Total number of attributes: 7
Name Password Archseries Primary type Secondary type Monster type Effect type DEF Pendulum Scale Link Link Arrows ATK Level/Rank TCG status OCG status Artwork Modification date Errata
Attribute
Loading... (need help?)
No description has been provided for this image

Primary types¶

Total number of primary types: 7
Name Password Archseries Attribute Secondary type Monster type Effect type DEF Pendulum Scale Link Link Arrows ATK Level/Rank TCG status OCG status Artwork Modification date Errata
Primary type
Loading... (need help?)

Has effect discrimination¶

Has effect Effect No Effect
Primary type
Loading... (need help?)
No description has been provided for this image

Obs: Normal monster can have effect if it is pendulum

Is pendulum discrimination¶

Is Pendulum Pendulum Not Pendulum
Primary type
Loading... (need help?)
No description has been provided for this image

By attribute¶

Attribute DARK DIVINE EARTH FIRE LIGHT WATER WIND
Primary type
Loading... (need help?)
No description has been provided for this image

Secondary types¶

Total number of secondary types: 6
Name Password Archseries Attribute Primary type Monster type Effect type DEF Pendulum Scale ATK Level/Rank TCG status OCG status Artwork Modification date Errata
Secondary type
Loading... (need help?)
No description has been provided for this image

By attribute¶

Attribute DARK EARTH FIRE LIGHT WATER WIND
Secondary type
Loading... (need help?)
No description has been provided for this image

By secondary type¶

Secondary type Flip monster Gemini monster Spirit monster Toon monster Tuner monster Union monster All
Primary type
Loading... (need help?)
No description has been provided for this image

Monster types¶

Total number of monster types: 26
Name Password Archseries Attribute Primary type Secondary type Effect type DEF Pendulum Scale Link Link Arrows ATK Level/Rank TCG status OCG status Artwork Modification date Errata
Monster type
Loading... (need help?)
No description has been provided for this image

By Attribute¶

Attribute DARK DIVINE EARTH FIRE LIGHT WATER WIND
Monster type
Loading... (need help?)
No description has been provided for this image

By primary type¶

Primary type Effect Monster Fusion Monster Link Monster Normal Monster Ritual Monster Synchro Monster Xyz Monster nan
Monster type
Loading... (need help?)
No description has been provided for this image

By secondary type¶

Secondary type Flip monster Gemini monster Spirit monster Toon monster Tuner monster Union monster nan
Monster type
Loading... (need help?)
No description has been provided for this image

ATK¶

Total number of ATK values: 83
Name Password Archseries Attribute Primary type Secondary type Monster type Effect type DEF Pendulum Scale Link Link Arrows Level/Rank TCG status OCG status Artwork Modification date Errata
ATK
Loading... (need help?)
No description has been provided for this image

DEF¶

Total number of DEF values: 78
Name Password Archseries Attribute Primary type Secondary type Monster type Effect type Pendulum Scale Link Link Arrows ATK Level/Rank TCG status OCG status Artwork Modification date Errata
DEF
Loading... (need help?)
No description has been provided for this image

Level/Rank¶

Name Password Archseries Attribute Primary type Secondary type Monster type Effect type DEF Pendulum Scale ATK TCG status OCG status Artwork Modification date Errata
Level/Rank
Loading... (need help?)
No description has been provided for this image

ATK statistics¶

ATK
count mean std min 25% 50% 75% max
Level/Rank
Loading... (need help?)

DEF statistics¶

DEF
count mean std min 25% 50% 75% max
Level/Rank
Loading... (need help?)

Pendulum scale¶

Name Password Archseries Attribute Primary type Secondary type Monster type Effect type DEF ATK Level/Rank TCG status OCG status Artwork Modification date Errata
Pendulum Scale
Loading... (need help?)
No description has been provided for this image

ATK statistics¶

ATK
count mean std min 25% 50% 75% max
Pendulum Scale
Loading... (need help?)

DEF statistics¶

DEF
count mean std min 25% 50% 75% max
Pendulum Scale
Loading... (need help?)

Level/Rank statistics¶

Level/Rank
count mean std min 25% 50% 75% max
Pendulum Scale
Loading... (need help?)

Link¶

Name Password Archseries Attribute Monster type Effect type Link Arrows ATK TCG status OCG status Artwork Modification date Errata
Link
Loading... (need help?)
No description has been provided for this image

ATK statistics¶

ATK
count mean std min 25% 50% 75% max
Link
Loading... (need help?)

Link Arrows¶

By combination¶

Total number of link arrow combinations: 63
Name Password Archseries Attribute Monster type Effect type ATK TCG status OCG status Artwork Modification date Errata
Link Arrows
Loading... (need help?)
No description has been provided for this image

By unique¶

Name Password Archseries Attribute Monster type Effect type Link ATK TCG status OCG status Artwork Modification date Errata
Link Arrows
Loading... (need help?)
No description has been provided for this image

By link¶

Link 1 2 3 4 5 6
Link Arrows
Loading... (need help?)
No description has been provided for this image

Spell & Trap¶

Properties¶

Total number of properties: 9
Name Password Archseries Effect type TCG status OCG status Artwork Modification date Errata
Property
Loading... (need help?)
No description has been provided for this image

Effect type¶

Total number of effect types: 16
Name Password Card type Property Archseries TCG status OCG status Page name Page URL Artwork Modification date Errata Attribute Primary type Secondary type Monster type DEF Pendulum Scale Link Link Arrows ATK Level/Rank
Effect type
Loading... (need help?)

Card type discrimination¶

Card type Monster Card Spell Card Trap Card
Effect type
Loading... (need help?)
No description has been provided for this image

Archseries¶

Total number of Archseries: 751
Name Password Card type Property Effect type TCG status OCG status Page name Page URL Artwork Modification date Errata Attribute Primary type Secondary type Monster type DEF Pendulum Scale Link Link Arrows ATK Level/Rank
Archseries
Loading... (need help?)
No description has been provided for this image

By card type¶

Card type Monster Card Spell Card Trap Card All
Archseries
Loading... (need help?)

By primary type¶

Primary type Effect Monster Fusion Monster Link Monster Normal Monster Ritual Monster Synchro Monster Xyz Monster All
Archseries
Loading... (need help?)

By secondary type¶

Secondary type Flip monster Gemini monster Spirit monster Toon monster Tuner monster Union monster All
Archseries
Loading... (need help?)

By monster type¶

Monster type Aqua Beast Beast-Warrior Creator God Cyberse Dinosaur Divine-Beast Dragon Fairy Fiend Fish Illusion Insect Machine Plant Psychic Pyro Reptile Rock Sea Serpent Spellcaster Thunder Warrior Winged Beast Wyrm Zombie All
Archseries
Loading... (need help?)

By property¶

Property Continuous Spell Card Continuous Trap Card Counter Trap Card Equip Spell Card Field Spell Card Normal Spell Card Normal Trap Card Quick-Play Spell Card Ritual Spell Card All
Archseries
Loading... (need help?)

Artworks¶

Total number of cards with edited or alternate artworks: 675
Name Password TCG status OCG status Artwork
Loading... (need help?)
No description has been provided for this image

By card type¶

Card type Monster Card Spell Card Trap Card
Artwork
Loading... (need help?)

By primary type¶

Primary type Effect Monster Fusion Monster Link Monster Normal Monster Ritual Monster Synchro Monster Xyz Monster
Artwork
Loading... (need help?)

More granularity is unnecessary

Errata¶

Total number of cards with errata: 4870
Name Password TCG status OCG status Errata
Loading... (need help?)
Name Password Card type Property Archseries Effect type TCG status OCG status Page name Page URL Artwork Modification date Attribute Primary type Secondary type Monster type DEF Pendulum Scale Link Link Arrows ATK Level/Rank
Errata
Loading... (need help?)
No description has been provided for this image

By card type¶

Card type Monster Card Spell Card Trap Card
Errata
Loading... (need help?)

By primary type¶

Primary type Effect Monster Fusion Monster Link Monster Normal Monster Ritual Monster Synchro Monster Xyz Monster
Errata
Loading... (need help?)

More granularity is unnecessary

By artwork¶

Errata (Any,) (Name,) (Name, Type) (Type,)
Artwork
Loading... (need help?)

TCG & OCG status¶

TGC status¶

Total number of TCG status: 6
Name Password Card type Property Archseries Effect type OCG status Artwork Modification date Errata Attribute Primary type Secondary type Monster type DEF Pendulum Scale Link Link Arrows ATK Level/Rank
TCG status
Loading... (need help?)
No description has been provided for this image

By card type¶

TCG status Forbidden Illegal Limited Not yet released Semi-Limited
Card type
Loading... (need help?)
No description has been provided for this image

By monster type¶

TCG status Forbidden Illegal Limited Not yet released Semi-Limited
Monster type
Loading... (need help?)
No description has been provided for this image

By archseries¶

TCG status Forbidden Illegal Limited Semi-Limited Unlimited All
Archseries
Loading... (need help?)

OCG status¶

Total number of OCG status: 6
Name Password Card type Property Archseries Effect type TCG status Artwork Modification date Errata Attribute Primary type Secondary type Monster type DEF Pendulum Scale Link Link Arrows ATK Level/Rank
OCG status
Loading... (need help?)
No description has been provided for this image

By card type¶

OCG status Forbidden Illegal Limited Not yet released Semi-Limited
Card type
Loading... (need help?)
No description has been provided for this image

By monster type¶

OCG status Forbidden Illegal Limited Not yet released Semi-Limited
Monster type
Loading... (need help?)
No description has been provided for this image

By archseries¶

OCG status Forbidden Illegal Limited Not yet released Semi-Limited All
Archseries
Loading... (need help?)

TCG vs. OCG status¶

TCG status Forbidden Illegal Limited Not yet released Semi-Limited Unlimited nan
OCG status
Loading... (need help?)
No description has been provided for this image

Extras¶

Multiple secondary types¶

Name Password Card type Property Archseries Effect type TCG status OCG status Page name Page URL Artwork Modification date Errata Attribute Primary type Secondary type Monster type DEF Pendulum Scale Link Link Arrows ATK Level/Rank
Loading... (need help?)

Not yet released¶

Name Password Card type Property Archseries Effect type TCG status OCG status Page name Page URL Artwork Modification date Errata Attribute Primary type Secondary type Monster type DEF Pendulum Scale Link Link Arrows ATK Level/Rank
Loading... (need help?)

Counters and Tokens¶

Name Card type Archseries Attribute Primary type Monster type Effect type DEF ATK Level/Rank TCG status OCG status Page name Page URL Artwork Modification date Errata
Loading... (need help?)

Page name differs from card name¶

Name Password Card type Property Archseries Effect type TCG status OCG status Page name Page URL Artwork Modification date Errata Attribute Primary type Secondary type Monster type DEF Pendulum Scale Link Link Arrows ATK Level/Rank
Loading... (need help?)

Epilogue¶

Execution completed 24/12/2023 20:12 UTC

HTML export¶

Notebook saved to disk

---------------------------------------------------------------------------
KeyError                                  Traceback (most recent call last)
File /opt/conda/lib/python3.11/site-packages/pandas/core/indexes/base.py:3790, in Index.get_loc(self, key)
   3789 try:
-> 3790     return self._engine.get_loc(casted_key)
   3791 except KeyError as err:

File index.pyx:152, in pandas._libs.index.IndexEngine.get_loc()

File index.pyx:181, in pandas._libs.index.IndexEngine.get_loc()

File pandas/_libs/hashtable_class_helper.pxi:7080, in pandas._libs.hashtable.PyObjectHashTable.get_item()

File pandas/_libs/hashtable_class_helper.pxi:7088, in pandas._libs.hashtable.PyObjectHashTable.get_item()

KeyError: 'card type'

The above exception was the direct cause of the following exception:

KeyError                                  Traceback (most recent call last)
Cell In[73], line 1
----> 1 full_df[full_df["card type"].isna()]

File /opt/conda/lib/python3.11/site-packages/pandas/core/frame.py:3893, in DataFrame.__getitem__(self, key)
   3891 if self.columns.nlevels > 1:
   3892     return self._getitem_multilevel(key)
-> 3893 indexer = self.columns.get_loc(key)
   3894 if is_integer(indexer):
   3895     indexer = [indexer]

File /opt/conda/lib/python3.11/site-packages/pandas/core/indexes/base.py:3797, in Index.get_loc(self, key)
   3792     if isinstance(casted_key, slice) or (
   3793         isinstance(casted_key, abc.Iterable)
   3794         and any(isinstance(x, slice) for x in casted_key)
   3795     ):
   3796         raise InvalidIndexError(key)
-> 3797     raise KeyError(key) from err
   3798 except TypeError:
   3799     # If we have a listlike key, _check_indexing_error will raise
   3800     #  InvalidIndexError. Otherwise we fall through and re-raise
   3801     #  the TypeError.
   3802     self._check_indexing_error(key)

KeyError: 'card type'